Owner

dbo

Creation Date

10-07-2003 10:31:36

Remarks

Columns

Name	Type	Length	IsNullable	Collation
ProductName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
ProductName	sysname	80		SQL_Latin1_General_CP1_CI_AS
UnitPrice	money	8

View Definition

create view "Products Above Average Price" AS
SELECT Products.ProductName, Products.UnitPrice
FROM Products
WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products)
--ORDER BY Products.UnitPrice DESC